<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="az137232">DROP TEXT SEARCH DICTIONARY</title><body><p id="sql_command_desc">Removes a text search dictionary.</p><section id="section2"><title>Synopsis</title></section>
    <codeblock id="sql_command_synopsis">DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] <varname>name</varname> [ CASCADE | RESTRICT ]</codeblock><section id="section3"><title>Description</title>
      <p><codeph>DROP TEXT SEARCH DICTIONARY</codeph> drops an existing text search dictionary. To
        run this command you must be the owner of the dictionary.</p></section><section id="section4"><title>Parameters</title>
      <parml>
        <plentry>
          <pt><codeph>IF EXISTS</codeph></pt>
          <pd>Do not throw an error if the text search dictionary does not exist. A notice is issued
            in this case.</pd>
        </plentry>
        <plentry>
          <pt><codeph><varname>name</varname></codeph></pt>
          <pd>The name (optionally schema-qualified) of an existing text search dictionary.</pd>
        </plentry>
        <plentry>
          <pt><codeph>CASCADE</codeph></pt>
          <pd>Automatically drop objects that depend on the text search dictionary.</pd>
        </plentry>
        <plentry>
          <pt><codeph>RESTRICT</codeph></pt>
          <pd>Refuse to drop the text search dictionary if any objects depend on it. This is the
            default.</pd>
        </plentry>
      </parml>
            
</section><section id="section5">
      <title>Examples</title>
      <p>Remove the text search dictionary <codeph>english</codeph>:</p>
      <codeblock>DROP TEXT SEARCH DICTIONARY english;</codeblock>
      <p>This command will not succeed if there are any existing text search configurations that use
        the dictionary. Add <codeph>CASCADE</codeph> to drop such configurations along with the
        dictionary.</p>
    </section><section
          id="section6"><title>Compatibility</title><p>There is no <codeph>CREATE TEXT SEARCH
            DICTIONARY</codeph> statement in the SQL standard.</p></section><section
              id="section7"><title>See Also</title><p><codeph><xref href="ALTER_TEXT_SEARCH_DICTIONARY.xml#topic1" type="topic" format="dita"
          /></codeph>, <codeph><xref href="./CREATE_TEXT_SEARCH_DICTIONARY.xml#topic1" type="topic"
            format="dita"/></codeph></p></section></body></topic>
